




use "data\data1_regional.dta", clear






******************* Table A11
******************* 

eststo R5: reg xCHN D_t_US D_t_MEX     xOTH Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip) 

esttab R5 using "results\w2\tA11.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
keep(D_t_US D_t_MEX     xOTH) mtitle("" "" "" "" "" "")  



******************* Table A13
******************* 

eststo clear
eststo R1: ivregress 2sls d_sh_empl_mfg  D_t_US D_t_MEX (xCHN=xOTH) [aw=time] , cluster(statefip)

eststo R2: ivregress 2sls d_sh_empl_mfg  D_t_US D_t_MEX (xCHN=xOTH) Lsh_manuf [aw=time] , cluster(statefip)

eststo R3: ivregress 2sls d_sh_empl_mfg  D_t_US D_t_MEX (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f  [aw=time] , cluster(statefip)

eststo R4: ivregress 2sls d_sh_empl_mfg  D_t_US D_t_MEX (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource  [aw=time] , cluster(statefip)

eststo R5: ivregress 2sls d_sh_empl_mfg  D_t_US D_t_MEX (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

esttab R1 R2 R3 R4 R5 using "results\w2\tA13.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
mtitle("" "" "" "" "" "")  


******************* Table A14 panel A
******************* 

eststo clear

***mftg
eststo R1: reg d_sh_empl_mfg  D_t_US_alt1 D_t_MEX_alt1  Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

eststo R2: ivregress 2sls d_sh_empl_mfg  D_t_US_alt1 D_t_MEX_alt1 (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** non-mftg
eststo R3: reg d_sh_empl_nmfg  D_t_US_alt1 D_t_MEX_alt1  Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

eststo R4: ivregress 2sls d_sh_empl_nmfg  D_t_US_alt1 D_t_MEX_alt1 (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** emp
eststo R5: reg d_sh_empl  D_t_US_alt1 D_t_MEX_alt1  Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

eststo R6: ivregress 2sls d_sh_empl  D_t_US_alt1 D_t_MEX_alt1 (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** unemp

eststo R7: reg d_sh_unempl  D_t_US_alt1 D_t_MEX_alt1  Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

eststo R8: ivregress 2sls d_sh_unempl  D_t_US_alt1 D_t_MEX_alt1 (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** nilf

eststo R9: reg d_sh_nilf  D_t_US_alt1 D_t_MEX_alt1  Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

eststo R10: ivregress 2sls d_sh_nilf  D_t_US_alt1 D_t_MEX_alt1 (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)


esttab R1 R2 R3 R4 R5 R6 R7 R8 R9 R10 using "results\w2\tA14A.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
mtitle("" "" "" "" "" "" "" "" "" "")  keep(D_t_US_alt1 D_t_MEX_alt1 xCHN) 



******************* Table A14 panel B
******************* 


eststo clear

***mftg
eststo R1: reg d_sh_empl_mfg  D_t_US_alt2 D_t_MEX_alt2  Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

eststo R2: ivregress 2sls d_sh_empl_mfg  D_t_US_alt2 D_t_MEX_alt2 (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** non-mftg
eststo R3: reg d_sh_empl_nmfg  D_t_US_alt2 D_t_MEX_alt2  Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

eststo R4: ivregress 2sls d_sh_empl_nmfg  D_t_US_alt2 D_t_MEX_alt2 (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** emp
eststo R5: reg d_sh_empl  D_t_US_alt2 D_t_MEX_alt2  Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

eststo R6: ivregress 2sls d_sh_empl  D_t_US_alt2 D_t_MEX_alt2 (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** unemp

eststo R7: reg d_sh_unempl  D_t_US_alt2 D_t_MEX_alt2  Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

eststo R8: ivregress 2sls d_sh_unempl  D_t_US_alt2 D_t_MEX_alt2 (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** nilf

eststo R9: reg d_sh_nilf  D_t_US_alt2 D_t_MEX_alt2  Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

eststo R10: ivregress 2sls d_sh_nilf  D_t_US_alt2 D_t_MEX_alt2 (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)


esttab R1 R2 R3 R4 R5 R6 R7 R8 R9 R10 using "results\w2\tA14B.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
mtitle("" "" "" "" "" "" "" "" "" "")  keep(D_t_US_alt2 D_t_MEX_alt2 xCHN) 





******************* Table A14 panel C
******************* 


eststo clear

***mftg
eststo R1: reg d_sh_empl_mfg  D_t_US_alt3 D_t_MEX_alt3  Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

eststo R2: ivregress 2sls d_sh_empl_mfg  D_t_US_alt3 D_t_MEX_alt3 (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** non-mftg
eststo R3: reg d_sh_empl_nmfg  D_t_US_alt3 D_t_MEX_alt3  Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

eststo R4: ivregress 2sls d_sh_empl_nmfg  D_t_US_alt3 D_t_MEX_alt3 (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** emp
eststo R5: reg d_sh_empl  D_t_US_alt3 D_t_MEX_alt3  Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

eststo R6: ivregress 2sls d_sh_empl  D_t_US_alt3 D_t_MEX_alt3 (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** unemp

eststo R7: reg d_sh_unempl  D_t_US_alt3 D_t_MEX_alt3  Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

eststo R8: ivregress 2sls d_sh_unempl  D_t_US_alt3 D_t_MEX_alt3 (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** nilf

eststo R9: reg d_sh_nilf  D_t_US_alt3 D_t_MEX_alt3  Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

eststo R10: ivregress 2sls d_sh_nilf  D_t_US_alt3 D_t_MEX_alt3 (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)


esttab R1 R2 R3 R4 R5 R6 R7 R8 R9 R10 using "results\w2\tA14C.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
mtitle("" "" "" "" "" "" "" "" "" "")  keep(D_t_US_alt3 D_t_MEX_alt3 xCHN) 




******************* Table A15 panel A
******************* 



eststo clear

***mftg
eststo R1: reg d_sh_empl_mfg  D_t_US D_t_MEX  xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** non-mftg
eststo R3: reg d_sh_empl_nmfg  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** emp
eststo R5: reg d_sh_empl  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** unemp

eststo R7: reg d_sh_unempl  D_t_US D_t_MEX  xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** nilf

eststo R9: reg d_sh_nilf  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)


esttab R1 R3 R5 R7 R9 using "results\w2\tA15A.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
mtitle("" "" "" "" "" "" "" "" "" "")  keep(D_t_US D_t_MEX xCHN) 







******************* Table A15 panel B
******************* 

eststo clear

***mftg
eststo R1: reg d_sh_empl_mfg_edu_nc  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** non-mftg
eststo R3: reg d_sh_empl_nmfg_edu_nc  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** emp
eststo R5: reg d_sh_empl_edu_nc  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** unemp
eststo R7: reg d_sh_unempl_edu_nc  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** nilf
eststo R9: reg d_sh_nilf_edu_nc  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)


esttab R1 R3 R5 R7 R9 using "results\w2\tA15B.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
mtitle("" "" "" "" "" "" "" "" "" "")   keep(D_t_US D_t_MEX xCHN)




******************* Table A15 panel C
******************* 

eststo clear

***mftg
eststo R1: reg d_sh_empl_mfg_edu_c  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** non-mftg

eststo R3: reg d_sh_empl_nmfg_edu_c  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** emp

eststo R5: reg d_sh_empl_edu_c  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** unemp

eststo R7: reg d_sh_unempl_edu_c  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** nilf

eststo R9: reg d_sh_nilf_edu_c  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)


esttab R1 R3 R5 R7 R9 using "results\w2\tA15C.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
mtitle("" "" "" "" "" "" "" "" "" "")   keep(D_t_US D_t_MEX xCHN)



******************* Table A15 panel D
******************* 


eststo clear

***mftg
eststo R1: reg d_sh_empl_mfg_f  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** non-mftg
eststo R3: reg d_sh_empl_nmfg_f  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** emp


eststo R5: reg d_sh_empl_f  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** unemp

eststo R7: reg d_sh_unempl_f  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** nilf

eststo R9: reg d_sh_nilf_f  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)


esttab R1 R3 R5 R7 R9 using "results\w2\tA15D.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
mtitle("" "" "" "" "" "" "" "" "" "")   keep(D_t_US D_t_MEX xCHN)





******************* Table A15 panel E
******************* 

eststo clear

***mftg
eststo R1: reg d_sh_empl_mfg_m  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** non-mftg
eststo R3: reg d_sh_empl_nmfg_m  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** emp

eststo R5: reg d_sh_empl_m  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** unemp

eststo R7: reg d_sh_unempl_m  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** nilf

eststo R9: reg d_sh_nilf_m  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)


esttab R1 R3 R5 R7 R9 using "results\w2\tA15E.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
mtitle("" "" "" "" "" "" "" "" "" "")   keep(D_t_US D_t_MEX xCHN)







******************* Table A15 panel F and G
******************* 

eststo clear

***mftg
eststo R1: reg d_sh_empl_mfg_nw  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R2: reg d_sh_empl_mfg_w  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** non-mftg
eststo R3: reg d_sh_empl_nmfg_nw  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R4: reg d_sh_empl_nmfg_w  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** emp

eststo R5: reg d_sh_empl_nw  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R6: reg d_sh_empl_w  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** unemp

eststo R7: reg d_sh_unempl_nw  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R8: reg d_sh_unempl_w  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** nilf

eststo R9: reg d_sh_nilf_nw  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R10: reg d_sh_nilf_w  D_t_US D_t_MEX xCHN Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)


esttab R1 R2 R3 R4 R5 R6 R7 R8 R9 R10 using "results\w2\tA15FG.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
mtitle("" "" "" "" "" "" "" "" "" "")   keep(D_t_US D_t_MEX xCHN)





******************* Table A16, panel A
******************* 

eststo clear

eststo R1: ivregress 2sls d_sh_empl_mfg_age1634  D_t_US D_t_MEX  (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R2: ivregress 2sls d_sh_empl_nmfg_age1634  D_t_US D_t_MEX  (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R3: ivregress 2sls d_sh_empl_age1634  D_t_US D_t_MEX  (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R4: ivregress 2sls d_sh_unempl_age1634  D_t_US D_t_MEX  (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R5: ivregress 2sls d_sh_nilf_age1634  D_t_US D_t_MEX  (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

esttab R1 R2 R3 R4 R5 using "results\w2\tA16A.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
mtitle("" "" "" "" "" "" "" "" "" "")  keep(D_t_US D_t_MEX xCHN) 

******************* Table A16, panel B
******************* 

eststo clear

eststo R1: ivregress 2sls d_sh_empl_mfg_age3549  D_t_US D_t_MEX  (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R2: ivregress 2sls d_sh_empl_nmfg_age3549  D_t_US D_t_MEX  (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R3: ivregress 2sls d_sh_empl_age3549  D_t_US D_t_MEX  (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R4: ivregress 2sls d_sh_unempl_age3549  D_t_US D_t_MEX  (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R5: ivregress 2sls d_sh_nilf_age3549  D_t_US D_t_MEX  (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

esttab R1 R2 R3 R4 R5 using "results\w2\tA16B.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
mtitle("" "" "" "" "" "" "" "" "" "")  keep(D_t_US D_t_MEX xCHN) 

******************* Table A16, panel C
******************* 

eststo clear

eststo R1: ivregress 2sls d_sh_empl_mfg_age5064  D_t_US D_t_MEX  (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R2: ivregress 2sls d_sh_empl_nmfg_age5064  D_t_US D_t_MEX  (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R3: ivregress 2sls d_sh_empl_age5064  D_t_US D_t_MEX  (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R4: ivregress 2sls d_sh_unempl_age5064  D_t_US D_t_MEX  (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R5: ivregress 2sls d_sh_nilf_age5064  D_t_US D_t_MEX  (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

esttab R1 R2 R3 R4 R5 using "results\w2\tA16C.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
mtitle("" "" "" "" "" "" "" "" "" "")  keep(D_t_US D_t_MEX xCHN) 





******************* TABLE A18
******************* 
	
eststo clear

ivregress 2sls d_sh_empl_abstract  D_t_US D_t_MEX (xCHN l_sh_routine33=xOTH R33a_1950_90) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_task_outsource i.div [aw=timepwt48] if yr == 1990, cluster(statefip) first

eststo R1: reg xCHN xOTH R33a_1950_90 D_t_US D_t_MEX Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f  l_task_outsource i.div [aw=timepwt48] if yr == 1990, cluster(statefip)

eststo R2: reg l_sh_routine33 R33a_1950_90 xOTH D_t_US D_t_MEX Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_task_outsource i.div [aw=timepwt48] if yr == 1990, cluster(statefip)

esttab R1 using "results\w2\tA18A.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
keep(D_t_US D_t_MEX xOTH) mtitle("" "" "" "" "" "")  

esttab R2 using "results\w2\tA18B.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
keep(D_t_US D_t_MEX R33a_1950_90) mtitle("" "" "" "" "" "")  




******************* TABLE A19
******************* 




eststo clear

** mftg emp

eststo R1: ivregress 2sls d_sh_empl_mfg   t_US_1990 t_MEX_1990     (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

eststo R2: ivregress 2sls d_sh_empl_mfg1990_2007 t_US_1990 t_MEX_1990     (xCHN_90_07 = xOTH_90_07 ) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

** nmftg emp

eststo R3: ivregress 2sls d_sh_empl_nmfg   t_US_1990 t_MEX_1990     (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

eststo R4: ivregress 2sls d_sh_empl_nmfg1990_2007 t_US_1990 t_MEX_1990     (xCHN_90_07 = xOTH_90_07 ) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)


** total emp

eststo R5: ivregress 2sls d_sh_empl t_US_1990 t_MEX_1990     (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

eststo R6: ivregress 2sls d_sh_empl1990_2007 t_US_1990 t_MEX_1990     (xCHN_90_07 = xOTH_90_07 ) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)


** unemp

eststo R7: ivregress 2sls d_sh_unempl t_US_1990 t_MEX_1990  (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

eststo R8: ivregress 2sls d_sh_unempl1990_2007 t_US_1990 t_MEX_1990     (xCHN_90_07 = xOTH_90_07 ) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

** nilf

eststo R9: ivregress 2sls d_sh_nilf t_US_1990 t_MEX_1990     (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

eststo R10: ivregress 2sls d_sh_nilf1990_2007 t_US_1990 t_MEX_1990     (xCHN_90_07 = xOTH_90_07 ) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)


esttab R1 R2 R3 R4 R5 R6 R7 R8 R9 R10 using "results\w2\tA19.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
mtitle("" "" "" "" "" "" "" "" "" "")   keep(t_US_1990 t_MEX_1990)






******************* Table A20 panel A
******************* 

eststo clear

***mftg
eststo R2: ivregress 2sls d_sh_empl_mfg_m_nc  D_t_US D_t_MEX (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** non-mftg
eststo R4: ivregress 2sls d_sh_empl_nmfg_m_nc  D_t_US D_t_MEX (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** emp

eststo R6: ivregress 2sls d_sh_empl_m_nc D_t_US D_t_MEX (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** unemp

eststo R8: ivregress 2sls d_sh_unempl_m_nc  D_t_US D_t_MEX (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** nilf

eststo R10: ivregress 2sls d_sh_nilf_m_nc  D_t_US D_t_MEX (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)


esttab R2 R4 R6 R8 R10 using "results\w2\tA20A.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
mtitle("" "" "" "" "" "" "" "" "" "")   keep(D_t_US D_t_MEX xCHN)



*******************
******************* Table A20 panel B

eststo clear

***mftg
eststo R2: ivregress 2sls d_sh_empl_mfg_f_nc  D_t_US D_t_MEX (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** non-mftg
eststo R4: ivregress 2sls d_sh_empl_nmfg_f_nc  D_t_US D_t_MEX (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** emp

eststo R6: ivregress 2sls d_sh_empl_f_nc D_t_US D_t_MEX (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** unemp

eststo R8: ivregress 2sls d_sh_unempl_f_nc  D_t_US D_t_MEX (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

*** nilf

eststo R10: ivregress 2sls d_sh_nilf_f_nc  D_t_US D_t_MEX (xCHN=xOTH) Lsh_manuf l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)


esttab R2 R4 R6 R8 R10 using "results\w2\tA20B.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
mtitle("" "" "" "" "" "" "" "" "" "")   keep(D_t_US D_t_MEX xCHN)

